About that Version 9.5 spreadsheet...

I grumbled about it earlier today but after using it for a couple hours now, I'm impressed. I don't know how they do it and I don't know who "they" are and who designed this spreadsheet but it does something I have never seen before. I think I'm relatively a smart guy for using Microsoft Office products but the trick that this spreadsheet does really made me say WOW!

There's a button on the side of the spreadsheet that says, "Create PowerPoint Slide." And after filling in the values for each of the required spaces on the sheet, I pushed the button. PowerPoint popped open, a blank chart appeared and then the results of my values populated the designated style chart automatically. There was nothing for me to do but fill in my name as the Program Manager and the program name.

That was sweet! The last time I did this set of charts, the automated chart did not work and so after producing the spreadsheet, the chart had to be manually produced, keeping all the values equal to the numbers on the spreadsheet. There was much formatting to be figured out. Now- none of that. Fill in the blanks on the spreadsheet, mash the button and wham! the chart is ready for review.

I wonder how they do that...